<?php

namespace common\models\mdm;

use Yii;

/**
 * This is the model class for table "MDM_ORG".
 *
 * @property string $PK_ORG
 * @property string $PK_GROUP
 * @property string $PK_ORG_V
 * @property string $PK_MDM_ORG
 * @property string $ORGCODE
 * @property string $ORGNAME
 * @property string $ORGORDERNAME
 * @property string $YYZZCODE
 * @property string $ORGCODECERT
 * @property string $BUSSCOPE
 * @property string $CSDJCODE
 * @property string $DSDJCODE
 * @property string $SETUPDATE
 * @property string $PROPBLUFD
 * @property string $CGBLUFD
 * @property string $ZCZEMONEY
 * @property string $HSMETHOD
 * @property string $STARTDATE
 * @property string $ENDDATE
 * @property string $ZCCAPUDF
 * @property string $SCCAPUFD
 * @property string $FRDBPOP
 * @property string $TXADRESS
 * @property string $ZIPCODE
 * @property string $PHONE
 * @property string $FAXCODE
 * @property string $COMPLXPOP
 * @property string $COMPINTRO
 * @property string $CREATOR
 * @property string $CREATIONTIME
 * @property string $MODIFIER
 * @property string $MODIFIEDTIME
 * @property string $VAPPROVEID
 * @property string $DAPPROVEDATE
 * @property string $VAPPROVENOTE
 * @property string $BILLCODE
 * @property integer $BILLSTATUS
 * @property string $TRANSTYPE
 * @property string $TRANSTYPEID
 * @property string $PK_BILLTYPE
 * @property string $PK_BUSITYPE
 * @property string $PK_DEF1
 * @property string $PK_DEF2
 * @property string $PK_DEF3
 * @property string $PK_DEF4
 * @property string $PK_DEF5
 * @property string $PK_DEF6
 * @property string $PK_DEF7
 * @property string $PK_DEF8
 * @property string $PK_DEF9
 * @property string $PK_DEF10
 * @property string $VVDEF1
 * @property string $VVDEF2
 * @property string $VVDEF3
 * @property string $VVDEF4
 * @property string $VVDEF5
 * @property string $VVDEF6
 * @property string $VVDEF7
 * @property string $VVDEF8
 * @property string $VVDEF9
 * @property string $VVDEF10
 * @property string $VVDEF11
 * @property string $VVDEF12
 * @property string $VVDEF13
 * @property string $VVDEF14
 * @property string $VVDEF15
 * @property string $VVDEF16
 * @property string $VVDEF17
 * @property string $VVDEF18
 * @property string $VVDEF19
 * @property string $VVDEF20
 * @property string $VVDEF21
 * @property string $VVDEF22
 * @property string $VVDEF23
 * @property string $VVDEF24
 * @property string $VVDEF25
 * @property string $VVDEF26
 * @property string $VVDEF27
 * @property string $VVDEF28
 * @property string $VVDEF29
 * @property string $VVDEF30
 * @property integer $IDEF1
 * @property integer $IDEF2
 * @property integer $IDEF3
 * @property integer $IDEF4
 * @property integer $IDEF5
 * @property integer $IDEF6
 * @property integer $IDEF7
 * @property integer $IDEF8
 * @property integer $IDEF9
 * @property integer $IDEF10
 * @property string $NDEF1
 * @property string $NDEF2
 * @property string $NDEF3
 * @property string $NDEF4
 * @property string $NDEF5
 * @property string $NDEF6
 * @property string $NDEF7
 * @property string $NDEF8
 * @property string $NDEF9
 * @property string $NDEF10
 * @property string $DDEF1
 * @property string $DDEF2
 * @property string $DDEF3
 * @property string $DDEF4
 * @property string $DDEF5
 * @property string $DDEF6
 * @property string $DDEF7
 * @property string $DDEF8
 * @property string $DDEF9
 * @property string $DDEF10
 * @property string $BDEF1
 * @property string $BDEF2
 * @property string $BDEF3
 * @property string $BDEF4
 * @property string $BDEF5
 * @property string $BDEF6
 * @property string $BDEF7
 * @property string $BDEF8
 * @property string $BDEF9
 * @property string $BDEF10
 * @property string $ISNOTUSE
 * @property string $NOTUSEDATE
 * @property string $NOTUSEMAN
 * @property string $ISVIRTUAL
 * @property integer $INVESTMENT
 * @property integer $TIMES
 * @property string $MONEY
 * @property string $PERCENT
 * @property string $MAINBODY
 * @property string $TS
 * @property integer $DR
 */
class MdmOrg extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'MDM_ORG';
    }

    /**
     * @return \yii\db\Connection the database connection used by this AR class.
     */
    public static function getDb()
    {
        return Yii::$app->get('db_mdm');
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['PK_MDM_ORG'], 'required'],
            [['BILLSTATUS', 'IDEF1', 'IDEF2', 'IDEF3', 'IDEF4', 'IDEF5', 'IDEF6', 'IDEF7', 'IDEF8', 'IDEF9', 'IDEF10', 'INVESTMENT', 'TIMES', 'DR'], 'integer'],
            [['NDEF1', 'NDEF2', 'NDEF3', 'NDEF4', 'NDEF5', 'NDEF6', 'NDEF7', 'NDEF8', 'NDEF9', 'NDEF10', 'MONEY', 'PERCENT'], 'number'],
            [['PK_ORG', 'PK_GROUP', 'PK_ORG_V', 'PK_MDM_ORG', 'CREATOR', 'MODIFIER', 'VAPPROVEID', 'TRANSTYPE', 'PK_BILLTYPE', 'PK_BUSITYPE', 'PK_DEF1', 'PK_DEF2', 'PK_DEF3', 'PK_DEF4', 'PK_DEF5', 'PK_DEF6', 'PK_DEF7', 'PK_DEF8', 'PK_DEF9', 'PK_DEF10', 'NOTUSEMAN'], 'string', 'max' => 20],
            [['ORGCODE', 'ORGORDERNAME', 'YYZZCODE', 'ORGCODECERT', 'CSDJCODE', 'DSDJCODE', 'PROPBLUFD', 'CGBLUFD', 'ZCZEMONEY', 'HSMETHOD', 'ZCCAPUDF', 'SCCAPUFD', 'FRDBPOP', 'ZIPCODE', 'PHONE', 'FAXCODE', 'COMPLXPOP', 'BILLCODE', 'TRANSTYPEID', 'VVDEF1', 'VVDEF2', 'VVDEF3', 'VVDEF4', 'VVDEF5', 'VVDEF6', 'VVDEF7', 'VVDEF8', 'VVDEF9', 'VVDEF10', 'VVDEF11', 'VVDEF12', 'VVDEF13', 'VVDEF14', 'VVDEF15', 'VVDEF16', 'VVDEF17', 'VVDEF18', 'VVDEF19', 'VVDEF20', 'VVDEF21', 'VVDEF22', 'VVDEF23', 'VVDEF24', 'VVDEF25', 'VVDEF26', 'VVDEF27', 'VVDEF28', 'VVDEF29', 'VVDEF30'], 'string', 'max' => 100],
            [['ORGNAME', 'TXADRESS'], 'string', 'max' => 200],
            [['BUSSCOPE'], 'string', 'max' => 1000],
            [['SETUPDATE', 'STARTDATE', 'ENDDATE', 'CREATIONTIME', 'MODIFIEDTIME', 'DAPPROVEDATE', 'DDEF1', 'DDEF2', 'DDEF3', 'DDEF4', 'DDEF5', 'DDEF6', 'DDEF7', 'DDEF8', 'DDEF9', 'DDEF10', 'NOTUSEDATE', 'TS'], 'string', 'max' => 19],
            [['COMPINTRO'], 'string', 'max' => 3000],
            [['VAPPROVENOTE'], 'string', 'max' => 1024],
            [['BDEF1', 'BDEF2', 'BDEF3', 'BDEF4', 'BDEF5', 'BDEF6', 'BDEF7', 'BDEF8', 'BDEF9', 'BDEF10', 'ISNOTUSE', 'ISVIRTUAL'], 'string', 'max' => 1],
            [['MAINBODY'], 'string', 'max' => 50],
            [['ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME'], 'unique', 'targetAttribute' => ['ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME', 'ORGNAME'], 'message' => 'The combination of  and Orgname has already been taken.'],
            [['PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG'], 'unique', 'targetAttribute' => ['PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG', 'PK_MDM_ORG'], 'message' => 'The combination of  and Pk  Mdm  Org has already been taken.'],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'PK_ORG' => Yii::t('app', 'Pk  Org'),
            'PK_GROUP' => Yii::t('app', 'Pk  Group'),
            'PK_ORG_V' => Yii::t('app', 'Pk  Org  V'),
            'PK_MDM_ORG' => Yii::t('app', 'Pk  Mdm  Org'),
            'ORGCODE' => Yii::t('app', 'Orgcode'),
            'ORGNAME' => Yii::t('app', 'Orgname'),
            'ORGORDERNAME' => Yii::t('app', 'Orgordername'),
            'YYZZCODE' => Yii::t('app', 'Yyzzcode'),
            'ORGCODECERT' => Yii::t('app', 'Orgcodecert'),
            'BUSSCOPE' => Yii::t('app', 'Busscope'),
            'CSDJCODE' => Yii::t('app', 'Csdjcode'),
            'DSDJCODE' => Yii::t('app', 'Dsdjcode'),
            'SETUPDATE' => Yii::t('app', 'Setupdate'),
            'PROPBLUFD' => Yii::t('app', 'Propblufd'),
            'CGBLUFD' => Yii::t('app', 'Cgblufd'),
            'ZCZEMONEY' => Yii::t('app', 'Zczemoney'),
            'HSMETHOD' => Yii::t('app', 'Hsmethod'),
            'STARTDATE' => Yii::t('app', 'Startdate'),
            'ENDDATE' => Yii::t('app', 'Enddate'),
            'ZCCAPUDF' => Yii::t('app', 'Zccapudf'),
            'SCCAPUFD' => Yii::t('app', 'Sccapufd'),
            'FRDBPOP' => Yii::t('app', 'Frdbpop'),
            'TXADRESS' => Yii::t('app', 'Txadress'),
            'ZIPCODE' => Yii::t('app', 'Zipcode'),
            'PHONE' => Yii::t('app', 'Phone'),
            'FAXCODE' => Yii::t('app', 'Faxcode'),
            'COMPLXPOP' => Yii::t('app', 'Complxpop'),
            'COMPINTRO' => Yii::t('app', 'Compintro'),
            'CREATOR' => Yii::t('app', 'Creator'),
            'CREATIONTIME' => Yii::t('app', 'Creationtime'),
            'MODIFIER' => Yii::t('app', 'Modifier'),
            'MODIFIEDTIME' => Yii::t('app', 'Modifiedtime'),
            'VAPPROVEID' => Yii::t('app', 'Vapproveid'),
            'DAPPROVEDATE' => Yii::t('app', 'Dapprovedate'),
            'VAPPROVENOTE' => Yii::t('app', 'Vapprovenote'),
            'BILLCODE' => Yii::t('app', 'Billcode'),
            'BILLSTATUS' => Yii::t('app', 'Billstatus'),
            'TRANSTYPE' => Yii::t('app', 'Transtype'),
            'TRANSTYPEID' => Yii::t('app', 'Transtypeid'),
            'PK_BILLTYPE' => Yii::t('app', 'Pk  Billtype'),
            'PK_BUSITYPE' => Yii::t('app', 'Pk  Busitype'),
            'PK_DEF1' => Yii::t('app', 'Pk  Def1'),
            'PK_DEF2' => Yii::t('app', 'Pk  Def2'),
            'PK_DEF3' => Yii::t('app', 'Pk  Def3'),
            'PK_DEF4' => Yii::t('app', 'Pk  Def4'),
            'PK_DEF5' => Yii::t('app', 'Pk  Def5'),
            'PK_DEF6' => Yii::t('app', 'Pk  Def6'),
            'PK_DEF7' => Yii::t('app', 'Pk  Def7'),
            'PK_DEF8' => Yii::t('app', 'Pk  Def8'),
            'PK_DEF9' => Yii::t('app', 'Pk  Def9'),
            'PK_DEF10' => Yii::t('app', 'Pk  Def10'),
            'VVDEF1' => Yii::t('app', 'Vvdef1'),
            'VVDEF2' => Yii::t('app', 'Vvdef2'),
            'VVDEF3' => Yii::t('app', 'Vvdef3'),
            'VVDEF4' => Yii::t('app', 'Vvdef4'),
            'VVDEF5' => Yii::t('app', 'Vvdef5'),
            'VVDEF6' => Yii::t('app', 'Vvdef6'),
            'VVDEF7' => Yii::t('app', 'Vvdef7'),
            'VVDEF8' => Yii::t('app', 'Vvdef8'),
            'VVDEF9' => Yii::t('app', 'Vvdef9'),
            'VVDEF10' => Yii::t('app', 'Vvdef10'),
            'VVDEF11' => Yii::t('app', 'Vvdef11'),
            'VVDEF12' => Yii::t('app', 'Vvdef12'),
            'VVDEF13' => Yii::t('app', 'Vvdef13'),
            'VVDEF14' => Yii::t('app', 'Vvdef14'),
            'VVDEF15' => Yii::t('app', 'Vvdef15'),
            'VVDEF16' => Yii::t('app', 'Vvdef16'),
            'VVDEF17' => Yii::t('app', 'Vvdef17'),
            'VVDEF18' => Yii::t('app', 'Vvdef18'),
            'VVDEF19' => Yii::t('app', 'Vvdef19'),
            'VVDEF20' => Yii::t('app', 'Vvdef20'),
            'VVDEF21' => Yii::t('app', 'Vvdef21'),
            'VVDEF22' => Yii::t('app', 'Vvdef22'),
            'VVDEF23' => Yii::t('app', 'Vvdef23'),
            'VVDEF24' => Yii::t('app', 'Vvdef24'),
            'VVDEF25' => Yii::t('app', 'Vvdef25'),
            'VVDEF26' => Yii::t('app', 'Vvdef26'),
            'VVDEF27' => Yii::t('app', 'Vvdef27'),
            'VVDEF28' => Yii::t('app', 'Vvdef28'),
            'VVDEF29' => Yii::t('app', 'Vvdef29'),
            'VVDEF30' => Yii::t('app', 'Vvdef30'),
            'IDEF1' => Yii::t('app', 'Idef1'),
            'IDEF2' => Yii::t('app', 'Idef2'),
            'IDEF3' => Yii::t('app', 'Idef3'),
            'IDEF4' => Yii::t('app', 'Idef4'),
            'IDEF5' => Yii::t('app', 'Idef5'),
            'IDEF6' => Yii::t('app', 'Idef6'),
            'IDEF7' => Yii::t('app', 'Idef7'),
            'IDEF8' => Yii::t('app', 'Idef8'),
            'IDEF9' => Yii::t('app', 'Idef9'),
            'IDEF10' => Yii::t('app', 'Idef10'),
            'NDEF1' => Yii::t('app', 'Ndef1'),
            'NDEF2' => Yii::t('app', 'Ndef2'),
            'NDEF3' => Yii::t('app', 'Ndef3'),
            'NDEF4' => Yii::t('app', 'Ndef4'),
            'NDEF5' => Yii::t('app', 'Ndef5'),
            'NDEF6' => Yii::t('app', 'Ndef6'),
            'NDEF7' => Yii::t('app', 'Ndef7'),
            'NDEF8' => Yii::t('app', 'Ndef8'),
            'NDEF9' => Yii::t('app', 'Ndef9'),
            'NDEF10' => Yii::t('app', 'Ndef10'),
            'DDEF1' => Yii::t('app', 'Ddef1'),
            'DDEF2' => Yii::t('app', 'Ddef2'),
            'DDEF3' => Yii::t('app', 'Ddef3'),
            'DDEF4' => Yii::t('app', 'Ddef4'),
            'DDEF5' => Yii::t('app', 'Ddef5'),
            'DDEF6' => Yii::t('app', 'Ddef6'),
            'DDEF7' => Yii::t('app', 'Ddef7'),
            'DDEF8' => Yii::t('app', 'Ddef8'),
            'DDEF9' => Yii::t('app', 'Ddef9'),
            'DDEF10' => Yii::t('app', 'Ddef10'),
            'BDEF1' => Yii::t('app', 'Bdef1'),
            'BDEF2' => Yii::t('app', 'Bdef2'),
            'BDEF3' => Yii::t('app', 'Bdef3'),
            'BDEF4' => Yii::t('app', 'Bdef4'),
            'BDEF5' => Yii::t('app', 'Bdef5'),
            'BDEF6' => Yii::t('app', 'Bdef6'),
            'BDEF7' => Yii::t('app', 'Bdef7'),
            'BDEF8' => Yii::t('app', 'Bdef8'),
            'BDEF9' => Yii::t('app', 'Bdef9'),
            'BDEF10' => Yii::t('app', 'Bdef10'),
            'ISNOTUSE' => Yii::t('app', 'Isnotuse'),
            'NOTUSEDATE' => Yii::t('app', 'Notusedate'),
            'NOTUSEMAN' => Yii::t('app', 'Notuseman'),
            'ISVIRTUAL' => Yii::t('app', 'Isvirtual'),
            'INVESTMENT' => Yii::t('app', 'Investment'),
            'TIMES' => Yii::t('app', 'Times'),
            'MONEY' => Yii::t('app', 'Money'),
            'PERCENT' => Yii::t('app', 'Percent'),
            'MAINBODY' => Yii::t('app', 'Mainbody'),
            'TS' => Yii::t('app', 'Ts'),
            'DR' => Yii::t('app', 'Dr'),
        ];
    }
}
